Modifying EDI Files by Opening in XLS
I have an EDI file ... I want to check it ... so when I open it it opens in an EXCEL file ... there is some data that I want to change ....
BGS ~ EGI ~ PG ~ 265 \ TIA ~ 5008 ~~~ 16796 ~ GA \ BGS ~ EGI ~ PG ~ 360 \ TIA ~ 5008 ~~~ 22827 ~ GA \ BGS ~ EGI ~ PG ~ 528 \ TIA ~ 5008 ~~~ 18304 ~ GA \
TO
BGS ~ EGI ~ PG ~ 265 \ TIA ~ 5008 ~~~ 0 ~ GA \ BGS ~ EGI ~ PG ~ 360 \ TIA ~ 5008 ~~~ 0 ~ GA \ BGS ~ EGI ~ PG ~ 528 \ TIA ~ 5008 ~~~ 0 ~ GA \
Can this be done on EXCEL and the changes will be reflected in the EDI sheet? If you do it in EXCEL and save ... how to save it? I did it, but didn't know which format to save ... xlt / xls / etc. I save it as .xlt format.Is what's the correct path?
Next, the cursors just go hay when I click on a cell. How to manage a cell?
PLEASE HELP
source to share
ATorras is on the right track. EDI is a kind of text format. I would call it more binary. (There's also XML EDI, but that's not what you're dealing with here.)
Depending on the size of the file, in some editions you may encounter line restrictions. Others may add line breaks, which may or may not cause problems with some EDI translators.
You can have binary delimited EDI files (like segment terminators). This is not common and it doesn't look like your test data.
The file extension is only relevant for translator or other software that tries to find / send an EDI file. Basically you don't want to change the original extension.
I don't remember what the standards are for Unicode, etc., so this can be a problem in some cases. You want to keep whatever encoding used by the original file.
Short version: Most of the time, you can avoid using Notepad, vi, etc. Sometimes you can't. If you have access to dedicated parsing / editing / translation EDI tools, use them. Never use Excel or Word. Always back up the original. Make sure your trading partner gets what you expect.
source to share