Sage 100

Importing into a 500-character UDF field. The source file has carriage returns and/or bullet points which are treated as new records. Am I missing something easy?? TIA.

If I recall, I've had to replace the carriage returns with only a line feed ascii symbol.

It is in Excel (saving as CSV). Will give it a shot.

You likely need to strip them prior to VI reading the file. If it is in excel you can do a change and replace on the column

You can also use the CLEAN() function which will remove all those pesky ascii characters

Copy the carriage return and then paste it in the search and replace tool.

Edit: I was thinking you were trying to preserve the characters in the UDf. I've used one of the following options in the past. 1. Import with supported excel file as source. 2. Replace all line feeds and carriage returns in source with a character not used in the data, then in the VI job, replace said character with chr(10). 3. Create a ODBC DSN pointing to the text file and use said DSN as source.

I've always used character substitution, but I'm wondering if importing from an Excel file format (instead of CSV) might allow for the data to be imported without editing (assuming the value is all in one cell).

Kevin ... carriage return are still going to cause an issue because Sage just converts to a flat file and reads it in.

Well, that's just silly.

And THAT'S why we have Monty Python and SNL :)

@JimWoodhead , I thought I've used excel successfully before in the past but i usually have to fallback to my 3rd or 2nd option depending on the client's server. So i have not tried my 1st option recently. I know for sure that MS' ODBC text driver will preserve line feeds without splitting it into another record as long as the line feed isn't accompanied with a carriage return.

What's the ascii symbol for a bullet point?? Anyone?

Can you copy and paste in the replace in excel search and replace?

No, it didn't work. Can't copy the carriage returns either. So far, the closest I've come is to use the clean() fcn - thanks @MichelleForsey - and now I'm trying to replace in Crystal (sorry, my goto tool).

hi - Isnt the bulletpoint a masked * symbol? (ascii code 42)?

Therese. Char(10) is return. and char(13) Line feed. Although you can use Ctrl -j in the file field and replace with either a space or a comma.

For bullets. You hit the alt key and type 0149 a bullet symbol should pop up. You can use this in find and replace.

I'm wondering if my post in this other thread will be of help: https://90minds-com.socialcast.com/messages/37189448?ref=stream