标题翻译
Parsing to excel
问题
我有很多行看起来像下面这样:
问题是,当我解析它时,两者之间只有一个空格。
我需要捕捉描述 / 参考 / 数量,它们是
( 2.5 毫升 SST,血液采集 )
( RD25 )
( 1)
如果在 COLLECTION 和 RD25 之后有两个空格,我可以将文本拆分为行,然后将行拆分为值,但由于只有一个空格并且值始终不同,我不能这样做,是否有人遇到过类似的问题?目标是解析每个页面上的行,然后导出到 Excel。谢谢
英文翻译
I have a lot of lines that looks as the following :
The problem is when I parse it just has one space in between
I need to capture Description / Reference / Quantity which is
( 2.5 ML SST, BLOOD COLLECTION )
( RD25 )
( 1)
If after COLLECTION and RD25 there was 2 space i could just split text to lines and lines into values but i cannot due to the fact that there is just one space and values always different, did anyone faced similar issues, the goal is to parse lines in each page and then export to Excel. Thank you
专注分享java语言的经验与见解,让所有开发者获益!
评论