| T O P I C R E V I E W |
| Draver |
Posted - 12/01/2022 : 05:18:25 AM
Origin Ver. and Service Release (Select Help-->About Origin): OriginPro 2022b (64-bit) SR1
Operating System: Windows 10
Hello everybody,
I am facing a problem when treating a worksheet with a large number of columns. I am importing multiple files (each file has 4 columns) and merge them into one big worksheet, where each file produces a new set of 4 columns. So basically my column pattern looks like this:
A1 B1 C1 D1 A2 B2 C2 D2 A3 B3 C3 D3 .....
Principally I know how to mark a column and set new values to it. I was just wondering if there is a way to multiply each 4th column (so the D columns) by a constant number, without the need to mark each of those columns individually and type the same formula over and over again?
Or even one step further: Is it possible to perform such operation already during the import?
Thank you very much in advance for your thoughts.
Kind regards
Stefan |
| 2 L A T E S T R E P L I E S (Newest First) |
| Draver |
Posted - 12/02/2022 : 04:37:01 AM
Dear James,
thank you very much. This is very helpful!!
Do you know if there is a good guide, which shows what things can be achieved by script commands?
Best wishes,
Stefan |
| YimingChen |
Posted - 12/01/2022 : 08:27:42 AM
In the import ASCII dialog, you can add a piece of script for each file import col(D) = 10*col(D).
James |
|
|
