The Origin Forum
File Exchange
Try Origin for Free
The Origin Forum
Home | Profile | Register | Active Topics | Members | Search | FAQ | Send File to Tech support
 All Forums
 Origin Forum
 Origin Forum
 2023: connecting/importing text lines

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!

Screensize:
UserName:
Password:
Anti-Spam Code:
Format Mode:
Format: BoldItalicizedUnderlineStrikethrough Align LeftCenteredAlign Right Horizontal Rule Insert HyperlinkUpload FileInsert Image Insert CodeInsert QuoteInsert List
   
Message:

* HTML is OFF
* Forum Code is ON
Smilies
Smile [:)] Big Smile [:D] Cool [8D] Blush [:I]
Tongue [:P] Evil [):] Wink [;)] Clown [:o)]
Black Eye [B)] Eight Ball [8] Frown [:(] Shy [8)]
Shocked [:0] Angry [:(!] Dead [xx(] Sleepy [|)]
Kisses [:X] Approve [^] Disapprove [V] Question [?]

 
Check here to subscribe to this topic.
   

T O P I C    R E V I E W
AKazak Posted - 11/16/2022 : 07:52:36 AM
OriginPro 2023 (64-bit) 10.0.0.154
Windows 7 Pro SP1 x64

Greetings!

I have a large text file and want to import each line to a single cell without any separation to columns. A1 should hold 1st text line from the input file and so on.

I tried to use Data | Connect to File and Data | Import from File, but these tools tend to perform column separation by default, at least I couldn't disable it.

Can you help me achieving the goal, please?

Thank you.

---
Andrey
6   L A T E S T    R E P L I E S    (Newest First)
AKazak Posted - 11/17/2022 : 9:49:42 PM
quote:
Originally posted by YimingChen

Andrey, can you clarify what you mean by "specify the effective codepage for text import" ?


I mean choose the effective encoding

and character set



---
Andrey
YimingChen Posted - 11/17/2022 : 2:32:54 PM
Andrey, can you clarify what you mean by "specify the effective codepage for text import" ?
AKazak Posted - 11/16/2022 : 9:03:10 PM
quote:
Originally posted by YimingChen

This worked:



Got it!
By the way, how do I specify the effective codepage for text import?

---
Andrey
YimingChen Posted - 11/16/2022 : 2:40:22 PM
This worked:
AKazak Posted - 11/16/2022 : 11:36:41 AM
quote:
Originally posted by YimingChen

As a work around, you can use Import Wizard to import the file (the tool allows setting delimiter) and create an import filter file. Then you can go to menu Data:Connect to File:Import Filter.. and connect to the file using the saved filter. Thank you.

James


Dear James,

I tried, but if I see the Delimiter to nothing Origin still separates the content by columns in preview window...
Can you share a screenshot of the import filter settings, please?

---
Andrey
YimingChen Posted - 11/16/2022 : 09:19:14 AM
As a work around, you can use Import Wizard to import the file (the tool allows setting delimiter) and create an import filter file. Then you can go to menu Data:Connect to File:Import Filter.. and connect to the file using the saved filter. Thank you.

James

The Origin Forum © 2020 Originlab Corporation Go To Top Of Page
Snitz Forums 2000