Let's say I have a cell that looks like this (with carriage returns):
email: [email protected]
destination: Ft Lauderdale on July 4 2020
************
other stuff
Is there a way within Sage 100 to extract just the value "Ft Lauderdale on July 4 2020"?
When you use ALT+ENTER in an Excel cell and save as CSV, excel converts this to just a Line Feed, which unfortunately VI will always see the Line Feed as a line separator which will cause it to split the line where ever the Line Feed is encountered. VI will however read a Carriage Return as the same line if it is not followed by a Line Feed. So if you can get your source to contain just the carriage returns, you can use a calculated column to replace the Carriage Return with another character or even replace just the Carriage Return with a Carriage Return + Line Feed so you can get the line breaks imported. This is useful in some fields like descriptions or line comments.
If your source column always starts with the same number of characters that you want to exclude, you can use the built in Substring feature.
If you need to extract a portion of a string based on a delimiter or character, you will need to use the Calculation field with a combination of the MID and POS functions.
When you use ALT+ENTER in an Excel cell and save as CSV, excel converts this to just a Line Feed, which unfortunately VI will always see the Line Feed as a line separator which will cause it to split the line where ever the Line Feed is encountered. VI will however read a Carriage Return as the same line if it is not followed by a Line Feed. So if you can get your source to contain just the carriage returns, you can use a calculated column to replace the Carriage Return with another character or even replace just the Carriage Return with a Carriage Return + Line Feed so you can get the line breaks imported. This is useful in some fields like descriptions or line comments.
If your source column always starts with the same number of characters that you want to exclude, you can use the built in Substring feature.
If you need to extract a portion of a string based on a delimiter or character, you will need to use the Calculation field with a combination of the MID and POS functions.
