JimHarrison
4 years agoQrew Champion
Finding Non-breaking spaces in imported data
We have an import tool that takes an Excel spreadsheet and imports the data into Quickbase.
We find there is an ASCII character char(160) that looks like a regular space but is read differently by other systems like SQL.
Options to solve the problem so far are as follows:
1. Use find & replace in Excel. Hold down right ALT and key in 0160 in the "Find What" field, then enter a Space in the "Replace with" field. This works great but we have to get Users to do it.
2. quickbase feature...
3. Use SQL to UPDATE
SELECT field, field1
FROM tablename
WHERE field1 LIKE '%' + char(160) + '%'
Wondering if anyone has knowledge/experience of parsing out non-breaking spaces with formula fields or pipelines.
Is it even possible to search for char(160) in Quickbase?
Thanks for reading, and if I get an answer I'll leave a note.
Jim Harrison
Portland, OR
------------------------------
Jim Harrison
transparency = knowledge + understanding : The Scrum Dudes
------------------------------
We find there is an ASCII character char(160) that looks like a regular space but is read differently by other systems like SQL.
Options to solve the problem so far are as follows:
1. Use find & replace in Excel. Hold down right ALT and key in 0160 in the "Find What" field, then enter a Space in the "Replace with" field. This works great but we have to get Users to do it.
2. quickbase feature...
3. Use SQL to UPDATE
SELECT field, field1
FROM tablename
WHERE field1 LIKE '%' + char(160) + '%'
Wondering if anyone has knowledge/experience of parsing out non-breaking spaces with formula fields or pipelines.
Is it even possible to search for char(160) in Quickbase?
Thanks for reading, and if I get an answer I'll leave a note.
Jim Harrison
Portland, OR
------------------------------
Jim Harrison
transparency = knowledge + understanding : The Scrum Dudes
------------------------------