on 09-16-2014 5:11 AM
Hello All:
I am using the GetFile Download file (read) getting a delimited flat file. But it doesn't use any field delimiter (tried both txt and csv file). So you end up getting a element like
<col>A,B,C,D<col>
I have not been able to figure out a way to do delimiter string split without a recursive template match, which I can't do within the template structure B1if gives. I am not too sure how to resolve this, I don't see any string split function from the XLST library.
Thank you for any help!
Hi,
the "GetFile" atom does not yet support the "Format Control Document" functionality.
If you need to read in a CSV file and define a logic to split via specified delimiter, please use the File Inbound logic. Details of the usage of file inbound can be found in the embedded B1i help.
SAP plans to harmonize the functionality of "file inbound" and the "GetFile" atom in future patchlevels of B1if.
Best regards
Bastian
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Bastian:
Thank you, yes I am currently already using the File Inbound logic, this is a second file after the initial file read in. A side question, for the inbound file I simply used \t on the delimiter in SLD and result yield how I wanted. I have seen the format control document, but haven't gotten any detail instructions on how to create one. Is it in the help document?
User | Count |
---|---|
91 | |
7 | |
7 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.