解析为Excel

huangapple 未分类评论68阅读模式
标题翻译

Parsing to excel

问题

我有很多行看起来像下面这样:

解析为Excel

问题是,当我解析它时,两者之间只有一个空格。

解析为Excel

我需要捕捉描述 / 参考 / 数量,它们是

( 2.5 毫升 SST,血液采集 )
( RD25 )
( 1)

如果在 COLLECTION 和 RD25 之后有两个空格,我可以将文本拆分为行,然后将行拆分为值,但由于只有一个空格并且值始终不同,我不能这样做,是否有人遇到过类似的问题?目标是解析每个页面上的行,然后导出到 Excel。谢谢

英文翻译

I have a lot of lines that looks as the following :

解析为Excel

The problem is when I parse it just has one space in between

解析为Excel

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

huangapple
  • 本文由 发表于 2020年1月30日 19:46:03
  • 转载请务必保留本文链接:https://java.coder-hub.com/59985356.html
匿名

发表评论

匿名网友

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen:

确定