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
Username:
 Password:
Save Password
Forgot your Password? | Admin Options

 All Forums
 Origin Forum
 Origin Forum
 2023: connecting/importing text lines		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic

AKazak

Russia
1235 Posts
Posted - 11/16/2022 :  07:52:36 AM  Show Profile  Edit Topic  Reply with Quote  View user's IP address  Delete Topic
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

YimingChen

1691 Posts
Posted - 11/16/2022 :  09:19:14 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
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
Go to Top of Page

AKazak

Russia
1235 Posts
Posted - 11/16/2022 :  11:36:41 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
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
Go to Top of Page

YimingChen

1691 Posts
Posted - 11/16/2022 :  2:40:22 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
This worked:
Go to Top of Page

AKazak

Russia
1235 Posts
Posted - 11/16/2022 :  9:03:10 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
quote:
Originally posted by YimingChen

This worked:



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

---
Andrey
Go to Top of Page

YimingChen

1691 Posts
Posted - 11/17/2022 :  2:32:54 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Andrey, can you clarify what you mean by "specify the effective codepage for text import" ?
Go to Top of Page

AKazak

Russia
1235 Posts
Posted - 11/17/2022 :  9:49:42 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
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
Go to Top of Page
  Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
The Origin Forum © 2020 Originlab Corporation Go To Top Of Page
Snitz Forums 2000