通过在 XLS 中打开来更改 EDI 文件
我有一个 EDI 文件...我想测试它...所以当我打开它时它会在 EXCEL 文件中打开，...有一些我想更改的数据...
BGS~EGI~PG ~265\TIA~5008~~~16796~GA\BGS~EGI~PG~360\TIA~5008~~~22827~GA\BGS~EGI~PG~528\TIA~5008~~~18304~GA\
至
BGS~EGI~PG~265\TIA~5008~~~0~GA\BGS~EGI~PG~360\TIA~5008~~~0~GA\BGS~EGI~PG~528\TIA~5008~~~ 0~GA\
可以在 EXCEL 上完成并将更改反映在 EDI 工作表中吗？如果在 EXCEL 中完成并保存....如何保存它？我这样做了，但不知道要保存哪种格式.... xlt/xls/ 等。我将其保存为 .xlt 格式。这是正确的方法吗？
此外，当我点击一个单元格时，光标就会变得混乱。如何控制细胞？
请帮忙
I have a EDI file ...i want to test it ....so when I open it it opens in an EXCEL file,....there is some data 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 it be done on EXCEL and the changes reflect in the EDI sheet?If do that in EXCEL and save ....how to save it?I did that but did not know which format to Save....xlt/xls/ etc. I save it as .xlt format.Is that the correct way?
Further the cursers just goes hay way when i click on a cell. How to control the cell?
pLEASE HELP
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
阿托拉斯走在正确的道路上。 EDI 是某种一种文本格式。我更愿意称其为二进制格式。 （还有 XML EDI，但这不是您在这里处理的内容。）
根据文件的大小，您可能会在某些编辑器中遇到行限制。其他人可能会添加换行符，这可能会或可能不会导致某些 EDI 转换器出现问题。
您可以拥有带有二进制分隔符（例如段终止符）的 EDI 文件。这种情况并不常见，而且您的测试数据看起来也并非如此。
文件扩展名仅对翻译器或尝试查找/发送 EDI 文件的其他软件重要。基本上你不想改变原来的扩展名。
我不记得 Unicode 等的标准是什么，所以在某些情况下这可能是一个问题。您需要保留原始文件使用的任何编码。
简短版本：大多数时候您可以使用记事本、vi 等，但有时则不能。如果您可以使用专用的 EDI 工具进行解析/编辑/翻译，请使用这些工具。切勿使用 Excel 或 Word。始终先备份原始文件。验证您的贸易伙伴是否得到了您所期望的结果。
ATorras is on the right path. EDI is sort of a text format. I'd call it more of a binary format. (There's also XML EDI, but that's not what you're dealing with here.)
Depending on the size of the file, you may run into line limits in some editors. Others may be adding line breaks that may or may not cause issues with some EDI translators.
You can have EDI files with binary delimiters (such as segment terminators). This is not common, and it doesn't look like the case with your test data.
The file extension only matters to the translator or other software that's trying to find/send the EDI file. Basically you don't want to change the original extension.
I don't remember what the standards are for Unicode, etc., so that may be a concern in some cases. You'll want to preserve whatever encoding the original file uses.
Short version: Most of the time you can get away with using Notepad, vi, etc. Sometimes you can't. If you have access to dedicated EDI tools for parsing/editing/translating, use those. Never use Excel or Word. Always make a backup of your original first. Verify that your trading partner is getting what you expect.