Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
@swuehl - I saw this post and was hoping it could be adapted somehow
My source field has this format that is stored as varchar(max) in the database:
The only semi-useful thing I have figured out is how to strip the HTML using a module but it doesn't align the view into columns and rows like the image above.:
trim( StripHTML(BUILD_HOURS_TABLE)) as BUILD_HOURS_TABLE,
I am desperate for a solution to be able to take these RTF tables and get discrete columns and rows so that I can do some calculations. Use DEFECT_ID = 718 for an example. Does anyone have any ideas at all?
Hi, could you post an example of the original input field format, before stripping the html (maybe exported to a text file)?
How did you create the first screenshot?