Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Import raw EDI files into Word and unwrap?
- Thread starter EDIOPS
- Start date
- Thread starter
- #3
![[santa3]](/data/assets/smilies/santa3.gif "[santa3] [santa3]")
If you open the file in MS Word you can perform a "replace all" on the segment terminator (usually ' [single quote]) character with '^p which will place a carriage return after the single quote. You will need to use MS Notepad or another viewer to view the file to avoid the segments wrapping round. Hope this helps.
Hi...
I actually wrote a small program to do that... But I also use TextPad (shareware) as well as UltraEdit (30 days, but my company paid to use that)
I actually prefer to use the pattern matching feature so that I can view it in readable ascii while you work
To use Ultra Edit select the character that you wish to replace with CR/LF then
1.) Ctrl-R or select Replace from the Menu
2.) check Regular Expressions
3.) in the Find what box should be the character, sometimes it will look like a blacked out non character
4.) in the Replace with put in this two characters ^p
(that is the metacharacter(?) for carraige return)
Also as an extra hint, if you have multiple documents envelopes from different partners you can do this....
Replace: ISA
With: ^pISA
Be sure to be aware that regular expressions is on the next time! This is a problem if you use *, you would have to know to use ^* because * is a wildcard character.... such that "P[a-z]*l is cool" matches "Paul is cool" and "Paaaaaaaaaaal is cool"
With Textpad, it is easy as well, but it uses the UNIX style of pattern matching, which I prefer.
Select the character in question, run replace from the menu or press F8, check regular expression on and replace with \n
The help menu for either of these programs will give you some more info...
Hey but if you want to buy a copy the program that I wrote...
I actually wrote a small program to do that... But I also use TextPad (shareware) as well as UltraEdit (30 days, but my company paid to use that)
I actually prefer to use the pattern matching feature so that I can view it in readable ascii while you work
To use Ultra Edit select the character that you wish to replace with CR/LF then
1.) Ctrl-R or select Replace from the Menu
2.) check Regular Expressions
3.) in the Find what box should be the character, sometimes it will look like a blacked out non character
4.) in the Replace with put in this two characters ^p
(that is the metacharacter(?) for carraige return)
Also as an extra hint, if you have multiple documents envelopes from different partners you can do this....
Replace: ISA
With: ^pISA
Be sure to be aware that regular expressions is on the next time! This is a problem if you use *, you would have to know to use ^* because * is a wildcard character.... such that "P[a-z]*l is cool" matches "Paul is cool" and "Paaaaaaaaaaal is cool"
With Textpad, it is easy as well, but it uses the UNIX style of pattern matching, which I prefer.
Select the character in question, run replace from the menu or press F8, check regular expression on and replace with \n
The help menu for either of these programs will give you some more info...
Hey but if you want to buy a copy the program that I wrote...
- Thread starter
- #6
Thanks to all who replied with suggestions! I found that using UltraEdit in Hex mode and replacing segment delimiter with CRLF was quickest and easiest way for me - at least for this particular problem. We do use Textpad here, which usually works better for our translated flat files than the raw EDI files. I will definitely keep the other ideas in mind for future use though!
- Status
Similar threads
- Locked
- Question