varchar(max) to table view

cbaqir — Sat, 16 Nov 2024 18:01:30 GMT

@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?

Re: varchar(max) to table view

swuehl — Wed, 07 Oct 2020 13:48:34 GMT

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?

topic varchar(max) to table view in QlikView

varchar(max) to table view

Re: varchar(max) to table view