izzy_babcock
New Contributor II
Joined 4 years ago
User Profile
User Widgets
Contributions
How to split a value into multiple fields
Hello, Say I have a .csv with the following row: value1_value2_value3_value4_value5 How can I split the string by “_” so each value can be mapped to its own field? I basically need to do stuff with each record, but through the Mapper I can’t seem to figure out how to accomplish this. Mapping from: “value1_value2_value3_value4_value5” To: “value1” “value2” “value3” “value4” “value5” Thank you in advance. Best, Izzy BabcockSolved5.9KViews0likes2CommentsRe: How to list file names from an FTP in another file?
Hi @Spiro_Taleski, Thank you for sharing this sample pipeline with me. When I run it (after updating it so it reflects my files), the result is an .xlsx with binary content, but I thought that the file writer would read binary and write it as document to the endpoint. Am I missing something? Also, how do you know that $Name references the name of the file in a directory? How do I know what can be referenced as a variable/field for a specific snap? Thanks in advance. Best, Izzy Babcock3.3KViews0likes2CommentsRe: How to list file names from an FTP in another file?
Hi @Spiro_Taleski, For now, it would suffice to have an excel file where each row will contain the name of the file. How do I reference the file name in the mapper? Is there a document listing all $fields that can be referenced on a particular snap? Best, Izzy Babcock4KViews0likes0CommentsHow to list file names from an FTP in another file?
Hello snapLogic Community! I am very new to the solution, but loving it more each day 🙂 I am trying to read the name of files from an FTP directory and write the details to a separate file within the pipeline project folder. I checked this post’s response, but this is listing assets in the SnapLogic environment, and I am looking to list the name of all files in an FTP location and print out the name of the files to a csv file or json. Does anyone have any suggestions on how I can accomplish this? Thank you in advance!Solved7.9KViews0likes8Comments